<center>
  <p>
    Category
  </p>
  <table width="100%" border="1">
  <tr>
    <td width="216"><center>CatID</center></td>
    <td width="387"><center>CatName</center></td>
    <td width="157"><center>Delete</center></td>
    </tr>
<?php
  error_reporting(E_ERROR);
$host="localhost";
$username="root";
$pass_word="";
$db="SWGeekStore";
$Conn = mysql_connect( $host,$username,$pass_word) or die ("cannot connect");mysql_query("SET NAMES utf8",$Conn);
mysql_select_db($db) or die("cannot connect to database"); 

 	$sql = "select * from Category ";
	$query = mysql_db_query($db, $sql);
while($result = mysql_fetch_array($query)) {
?>  

  <tr>
    <td align="center"><?=$result[catId]?></td>
    <td align="center"><?=$result[catName]?></td>
    <td><center><input type="checkbox" name="checkbox" id="checkbox" />
      <label for="checkbox"></label></center></td>
    </tr><? } ?>
</table>
<p>&nbsp;</p>
<table align="right" width="30%" border="0">
  <tr>
<td align="right"><a href="index.php?view=add">Add New Category</td>
  </tr>
</table>
</center>
